Skip to main content

Following steps to create dataset using Flatfiles

  • From this document, you will learn to create a dataset in OPNBI, Also you will learn to make a dataset using Flatfiles. F

What is Flat-File?​

  • A flat file database is a collection of records in which the data follows a uniform format and follows rules on value types where applicable. The database is flat because every line only holds one data input, depending on the categorization of the columns.
info
  • Click here to know more about Flat-File in detail.

Objectives​

  • Create dataset using flat-files

Prerequisites​

  • For this example we are using worldcities.xlsx.

Download excel.zip file from link given excel.zip & use data from the file named worldcities.xlsx from it.

  1. Go to Hamburger Icon > Master Data > Dataset.

    Docusaurus Slash Introduction

  2. Click on Create Dataset, As shown in figure below:

    Docusaurus Slash Introduction

  3. Enter following details in Create Dataset.

  • Name: World Cities
  • Datasource: Flat Files
  • Copy Excel file data and Paste in Source window.

  1. Use worldcities.xlxs from the zip file you have downloaded at the start of this document to copy the required data.

  2. Fill above details, As shown in figure below:

    Docusaurus Slash Introduction

  3. Click on output Column Tab.

  4. Click on Preview and Submit button.

  5. You will see the World City Dataset, As shown in figure below:

    Docusaurus Slash Introduction

  6. Click on Hamburger menu > Dashboard section & create dashboard.

    Docusaurus Slash Introduction

info

  1. From Right Vertical Menu Select the Table Widget icon.

    Docusaurus Slash Introduction

info
  • CLick here to know more about different dashboard widgets.

  1. The Edit menu box appears as you click Table Widget icon. And a widget gets added in content place automatically in dashboard.

  2. Enter Following Details in edit box, As shown in figure below:

  • Dataset: World Cities
  • In Dataset Column Select all the field.

Docusaurus Slash Introduction

  1. Click on Preview and Save and Exit button.

  2. Now, match your Table Widget with the below example, it should look like the figure below:

    Docusaurus Slash Introduction

  • In this manner, you can create a new dataset for your Dashboard.

To know more about how to create dataset using different sources follow below Links:-

Dataset using CSV​

Dataset using JSON​

Dataset using External sources​

Dataset using Excel​

Dataset using Google BigQuery​

Dataset using noSQL ​

Dataset using Join​

Dataset using Union​

Dataset using Server Script​

Dataset using Client Script​

Dataset using Stored Procedure​

Dataset using View​

Dataset using Simple Query​

Dataset using Drag & Drop​